
USE `open_scriptures`;
BEGIN;

INSERT INTO license (name, abbreviation, url) VALUES(
	INSERT_TEXT(NULL, 'en', 'Public Domain', NULL),
	NULL, #INSERT_TEXT(NULL, 'en', 'public-domain', NULL),
	"http://creativecommons.org/licenses/publicdomain/"
);
SELECT INSERT_TEXT((SELECT name FROM license WHERE id = LAST_INSERT_ID()), 'es', 'Dominio público', NULL);


INSERT INTO license (name, abbreviation, url) VALUES(
	INSERT_TEXT(NULL, 'en', 'Creative Commons Attribution 3.0', NULL),
	INSERT_TEXT(NULL, 'en', 'CC-BY-3.0', NULL),
	"http://creativecommons.org/licenses/by/3.0/"
);

INSERT INTO license (name, abbreviation, url) VALUES(
	INSERT_TEXT(NULL, 'en', 'Creative Commons Attribution-No Derivative Works 3.0', NULL),
	INSERT_TEXT(NULL, 'en', 'CC-BY-ND-3.0', NULL),
	"http://creativecommons.org/licenses/by-nd/3.0/"
);

INSERT INTO license (name, abbreviation, url) VALUES(
	INSERT_TEXT(NULL, 'en', 'Creative Commons Attribution-Noncommercial-No Derivative Works 3.0', NULL),
	INSERT_TEXT(NULL, 'en', 'CC-BY-NC-ND-3.0', NULL),
	"http://creativecommons.org/licenses/by-nc-nd/3.0/"
);

INSERT INTO license (name, abbreviation, url) VALUES(
	INSERT_TEXT(NULL, 'en', 'Creative Commons Attribution-Noncommercial 3.0', NULL),
	INSERT_TEXT(NULL, 'en', 'CC-BY-NC-3.0', NULL),
	"http://creativecommons.org/licenses/by-nc/3.0/"
);

INSERT INTO license (name, abbreviation, url) VALUES(
	INSERT_TEXT(NULL, 'en', 'Creative Commons Attribution-Noncommercial-Share Alike 3.0', NULL),
	INSERT_TEXT(NULL, 'en', 'CC-BY-NC-SA-3.0', NULL),
	"http://creativecommons.org/licenses/by-nc-sa/3.0/"
);

INSERT INTO license (name, abbreviation, url) VALUES(
	INSERT_TEXT(NULL, 'en', 'Creative Commons Attribution-Share Alike 3.0', NULL),
	INSERT_TEXT(NULL, 'en', 'CC-BY-SA-3.0', NULL),
	"http://creativecommons.org/licenses/by-sa/3.0/"
);

INSERT INTO license (name, abbreviation, url) VALUES(
	INSERT_TEXT(NULL, 'en', 'MIT License', NULL),
	INSERT_TEXT(NULL, 'en', 'MIT', NULL),
	"http://creativecommons.org/licenses/MIT/"
);

INSERT INTO license (name, abbreviation, url) VALUES(
	INSERT_TEXT(NULL, 'en', 'GNU Free Documentation License', NULL),
	INSERT_TEXT(NULL, 'en', 'GFDL', NULL),
	"http://www.gnu.org/copyleft/fdl.html"
);

COMMIT;